0a06ba4d810f8911a0c56a44703a983326916a39,tests/frontend/org/voltdb/regressionsuites/TestFunctionsSuite.java,TestFunctionsSuite,testCaseWhen,#,2675

Before Change


        sql = "SELECT ID, CASE WHEN num < 3 THEN num/2 ELSE num + 10 END FROM R1 ORDER BY 1;";
        vt = cl.callProcedure("@AdHoc", sql).getResults()[0];
        assertEquals(VoltType.INTEGER, vt.getColumnType(1));
        if (isHSQL()) {
            validateTableOfLongs(vt, new long[][] {{1, 0},{2, 15}, {3, 18}, {4, 0}});
        } else {
            validateTableOfLongs(vt, new long[][] {{1, 0},{2, 15}, {3, 18}, {4, Long.MIN_VALUE}});
        }

    }

After Change


        sql = "SELECT ID, CASE WHEN num < 3 THEN num/2 ELSE num + 10 END FROM R1 ORDER BY 1;";
        vt = cl.callProcedure("@AdHoc", sql).getResults()[0];
        assertEquals(VoltType.INTEGER, vt.getColumnType(1));
        validateTableOfLongs(vt, new long[][] {{1, 0},{2, 15}, {3, 18}, {4, Long.MIN_VALUE}});

    }